<!doctype html>

<html lang="en">

 <head>

  <meta charset="UTF-8">  

  <title>用户列表</title>

 </head>

 <body>

 

 <?php

  require_once('inc_admin.php');
  require_once('nav.php');

  connect();

  //编写sql语句

  $sql = 'select * from users';

  //echo $sql.'<br/>';  

  $result = fetch_array($sql); 

   

 ?>

 <center><h3>用户列表</h3></center>

 <table align="center" width="80%" border=1> 

 <tr>

   <th>用户编号</th>

   <th>用户名</th>   

   <th>性别</th>

   <th>生日</th>

   <th>爱好</th>

   <th>学历</th>

   <th>自我介绍</th> 

   <th width='80'>头像</th>

   <th>操作</th>

 </tr>



 <?php

  foreach ($result as $row) {

	 echo '<tr>';

	 echo '<td>'.$row['uid'].'</td>';

	 echo '<td>'.$row['uname'].'</td>';	 

	 echo '<td>'.($row['gender']==0?'男':'女').'</td>';

	 echo '<td>'.$row['birthdate'].'</td>';

	 echo '<td>'.$row['hobby'].'</td>';

	 switch($row['degree']){

	   case '1':$dg = "高中";break;

	   case '2':$dg = "大学";break;

	   case '3':$dg = "研究生";break;

	   case '4':$dg = "博士生";break;

	   default: $dg="Don't know";

     }

	 echo '<td>'.$dg.'</td>';

	 echo '<td>'.$row['intro'].'</td>';	 	 

	 echo '<td align="center"><img src = "images/'.$row['pic'].' "width=60 height=80 alt="无头像"></td>';	 

	 echo '<td><a href="userEditForm.php?id='.$row['uid'].' ">修改</a> | 

	 <a href="userDelete.php?id='.$row['uid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';

	 echo '</tr>';  

  }

  echo '</table>';  

  $totalrows = count($result);

  echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>";   

 ?>

 

 </body>

</html>
<?php
require_once('footer.php');
?>


